Create proc proc_deleteVatTuHangHoa
(
 @MaVatTu varchar(10)
)
as
begin
	DELETE FROM [QuanLyKho].[dbo].[DonViTinh]
    WHERE @MaVatTu = [QuanLyKho].[dbo].DonViTinh.MaVatTu
	
	DELETE FROM [QuanLyKho].[dbo].[VatTuHangHoa]
    WHERE @MaVatTu = [QuanLyKho].[dbo].[VatTuHangHoa].MaVatTu
end
go

Create proc proc_deleteDonViTinh
(
 @STT int
)
as
DELETE FROM [QuanLyKho].[dbo].[DonViTinh]
      WHERE STT = @STT
GO

create proc proc_deleteKho
(
 @MaKho varchar(10)
)
as
DELETE FROM [QuanLyKho].[dbo].[Kho]
      WHERE MaKho = @MaKho
go      

Create proc proc_deleteTienTe
(
 @KyHieu varchar(10)
)
as
DELETE FROM [QuanLyKho].[dbo].[TienTe]
      WHERE KyHieu = @KyHieu
GO

Create proc proc_deleteNhapKhau
(
 @SoChungTu varchar(10),
 @Ngay		datetime
)
as
DELETE FROM [QuanLyKho].[dbo].[NhapKhau]
      WHERE SoChungTu = @SoChungTu
        and Ngay = @Ngay
GO

